<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DataSet" targetNamespace="http://tempuri.org/DataSet.xsd" xmlns:mstns="http://tempuri.org/DataSet.xsd" xmlns="http://tempuri.org/DataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString (Settings)" PropertyReference="ApplicationSettings.NBooks.Reports.Properties.Settings.GlobalReference.Default.ConnectionString" Provider="System.Data.Odbc" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="customersTableAdapter" GeneratorDataComponentClassName="customersTableAdapter" Name="customers" UserDataComponentName="customersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT * FROM `customers`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="address" DataSetColumn="address" />
              <Mapping SourceColumn="phone" DataSetColumn="phone" />
              <Mapping SourceColumn="trade_assistance" DataSetColumn="trade_assistance" />
              <Mapping SourceColumn="classification" DataSetColumn="classification" />
              <Mapping SourceColumn="type_of_deal" DataSetColumn="type_of_deal" />
              <Mapping SourceColumn="balance" DataSetColumn="balance" />
              <Mapping SourceColumn="inactive" DataSetColumn="inactive" />
              <Mapping SourceColumn="company_name" DataSetColumn="company_name" />
              <Mapping SourceColumn="balance_as_of" DataSetColumn="balance_as_of" />
              <Mapping SourceColumn="title" DataSetColumn="title" />
              <Mapping SourceColumn="first_name" DataSetColumn="first_name" />
              <Mapping SourceColumn="last_name" DataSetColumn="last_name" />
              <Mapping SourceColumn="middle_name" DataSetColumn="middle_name" />
              <Mapping SourceColumn="ship_to_address" DataSetColumn="ship_to_address" />
              <Mapping SourceColumn="contact" DataSetColumn="contact" />
              <Mapping SourceColumn="fax" DataSetColumn="fax" />
              <Mapping SourceColumn="alt_phone" DataSetColumn="alt_phone" />
              <Mapping SourceColumn="alt_contact" DataSetColumn="alt_contact" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
              <Mapping SourceColumn="cc" DataSetColumn="cc" />
              <Mapping SourceColumn="customer_type_id" DataSetColumn="customer_type_id" />
              <Mapping SourceColumn="terms_id" DataSetColumn="terms_id" />
              <Mapping SourceColumn="sales_rep_id" DataSetColumn="sales_rep_id" />
              <Mapping SourceColumn="send_method" DataSetColumn="send_method" />
              <Mapping SourceColumn="sales_tax_code_id" DataSetColumn="sales_tax_code_id" />
              <Mapping SourceColumn="tax_item_id" DataSetColumn="tax_item_id" />
              <Mapping SourceColumn="resale_number" DataSetColumn="resale_number" />
              <Mapping SourceColumn="price_level_id" DataSetColumn="price_level_id" />
              <Mapping SourceColumn="account_no" DataSetColumn="account_no" />
              <Mapping SourceColumn="credit_limit" DataSetColumn="credit_limit" />
              <Mapping SourceColumn="payment_method_id" DataSetColumn="payment_method_id" />
              <Mapping SourceColumn="credit_card_no" DataSetColumn="credit_card_no" />
              <Mapping SourceColumn="cc_expiry_month" DataSetColumn="cc_expiry_month" />
              <Mapping SourceColumn="cc_expiry_year" DataSetColumn="cc_expiry_year" />
              <Mapping SourceColumn="name_on_card" DataSetColumn="name_on_card" />
              <Mapping SourceColumn="cc_address" DataSetColumn="cc_address" />
              <Mapping SourceColumn="cc_zip_code" DataSetColumn="cc_zip_code" />
              <Mapping SourceColumn="job_status" DataSetColumn="job_status" />
              <Mapping SourceColumn="start_date" DataSetColumn="start_date" />
              <Mapping SourceColumn="projected_end" DataSetColumn="projected_end" />
              <Mapping SourceColumn="end_date" DataSetColumn="end_date" />
              <Mapping SourceColumn="job_description" DataSetColumn="job_description" />
              <Mapping SourceColumn="job_type_id" DataSetColumn="job_type_id" />
              <Mapping SourceColumn="notes" DataSetColumn="notes" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="vendorsTableAdapter" GeneratorDataComponentClassName="vendorsTableAdapter" Name="vendors" UserDataComponentName="vendorsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT * FROM `vendors`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="address" DataSetColumn="address" />
              <Mapping SourceColumn="phone" DataSetColumn="phone" />
              <Mapping SourceColumn="inactive" DataSetColumn="inactive" />
              <Mapping SourceColumn="balance" DataSetColumn="balance" />
              <Mapping SourceColumn="contact" DataSetColumn="contact" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="companyTableAdapter" GeneratorDataComponentClassName="companyTableAdapter" Name="company" UserDataComponentName="companyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT * FROM `company`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="ship_to_name" DataSetColumn="ship_to_name" />
              <Mapping SourceColumn="ship_to_address" DataSetColumn="ship_to_address" />
              <Mapping SourceColumn="address" DataSetColumn="address" />
              <Mapping SourceColumn="phone" DataSetColumn="phone" />
              <Mapping SourceColumn="fax" DataSetColumn="fax" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
              <Mapping SourceColumn="website" DataSetColumn="website" />
              <Mapping SourceColumn="legal_name" DataSetColumn="legal_name" />
              <Mapping SourceColumn="legal_address" DataSetColumn="legal_address" />
              <Mapping SourceColumn="legal_address1" DataSetColumn="legal_address1" />
              <Mapping SourceColumn="city" DataSetColumn="city" />
              <Mapping SourceColumn="state_id" DataSetColumn="state_id" />
              <Mapping SourceColumn="zip" DataSetColumn="zip" />
              <Mapping SourceColumn="legal_country_id" DataSetColumn="legal_country_id" />
              <Mapping SourceColumn="country_id" DataSetColumn="country_id" />
              <Mapping SourceColumn="fiscal_year" DataSetColumn="fiscal_year" />
              <Mapping SourceColumn="tax_year" DataSetColumn="tax_year" />
              <Mapping SourceColumn="income_tax_form" DataSetColumn="income_tax_form" />
              <Mapping SourceColumn="ein" DataSetColumn="ein" />
              <Mapping SourceColumn="ssn" DataSetColumn="ssn" />
              <Mapping SourceColumn="payroll_contact" DataSetColumn="payroll_contact" />
              <Mapping SourceColumn="payroll_contact_title" DataSetColumn="payroll_contact_title" />
              <Mapping SourceColumn="payroll_contact_phone" DataSetColumn="payroll_contact_phone" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="accountsTableAdapter" GeneratorDataComponentClassName="accountsTableAdapter" Name="accounts" UserDataComponentName="accountsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT * FROM `accounts`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="description" DataSetColumn="description" />
              <Mapping SourceColumn="note" DataSetColumn="note" />
              <Mapping SourceColumn="balance" DataSetColumn="balance" />
              <Mapping SourceColumn="inactive" DataSetColumn="inactive" />
              <Mapping SourceColumn="type" DataSetColumn="type" />
              <Mapping SourceColumn="tax_line_mapping" DataSetColumn="tax_line_mapping" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="itemsTableAdapter" GeneratorDataComponentClassName="itemsTableAdapter" Name="items" UserDataComponentName="itemsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT * FROM `items`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="sales_description" DataSetColumn="sales_description" />
              <Mapping SourceColumn="on_hand" DataSetColumn="on_hand" />
              <Mapping SourceColumn="unit_measure" DataSetColumn="unit_measure" />
              <Mapping SourceColumn="sales_price" DataSetColumn="sales_price" />
              <Mapping SourceColumn="reorder_point" DataSetColumn="reorder_point" />
              <Mapping SourceColumn="overstock_level" DataSetColumn="overstock_level" />
              <Mapping SourceColumn="part_number" DataSetColumn="part_number" />
              <Mapping SourceColumn="beginning_qty" DataSetColumn="beginning_qty" />
              <Mapping SourceColumn="tolarge_packing" DataSetColumn="tolarge_packing" />
              <Mapping SourceColumn="inactive" DataSetColumn="inactive" />
              <Mapping SourceColumn="ucs" DataSetColumn="ucs" />
              <Mapping SourceColumn="preferred_vendor_id" DataSetColumn="preferred_vendor_id" />
              <Mapping SourceColumn="vendor_discount" DataSetColumn="vendor_discount" />
              <Mapping SourceColumn="purchase_description" DataSetColumn="purchase_description" />
              <Mapping SourceColumn="cost" DataSetColumn="cost" />
              <Mapping SourceColumn="type" DataSetColumn="type" />
              <Mapping SourceColumn="unit_id" DataSetColumn="unit_id" />
              <Mapping SourceColumn="income_account_id" DataSetColumn="income_account_id" />
              <Mapping SourceColumn="cogs_account_id" DataSetColumn="cogs_account_id" />
              <Mapping SourceColumn="sales_tax_code_id" DataSetColumn="sales_tax_code_id" />
              <Mapping SourceColumn="asset_account_id" DataSetColumn="asset_account_id" />
              <Mapping SourceColumn="total_value" DataSetColumn="total_value" />
              <Mapping SourceColumn="value_as_of" DataSetColumn="value_as_of" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="invoicesTableAdapter" GeneratorDataComponentClassName="invoicesTableAdapter" Name="invoices" UserDataComponentName="invoicesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT * FROM `invoices`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="date" DataSetColumn="date" />
              <Mapping SourceColumn="customer_id" DataSetColumn="customer_id" />
              <Mapping SourceColumn="ref_no" DataSetColumn="ref_no" />
              <Mapping SourceColumn="bill_to_address" DataSetColumn="bill_to_address" />
              <Mapping SourceColumn="ship_to_address" DataSetColumn="ship_to_address" />
              <Mapping SourceColumn="po_no" DataSetColumn="po_no" />
              <Mapping SourceColumn="terms_id" DataSetColumn="terms_id" />
              <Mapping SourceColumn="sales_rep_id" DataSetColumn="sales_rep_id" />
              <Mapping SourceColumn="shipping_date" DataSetColumn="shipping_date" />
              <Mapping SourceColumn="shipping_method_id" DataSetColumn="shipping_method_id" />
              <Mapping SourceColumn="fob" DataSetColumn="fob" />
              <Mapping SourceColumn="customer_message_id" DataSetColumn="customer_message_id" />
              <Mapping SourceColumn="tax_item_id" DataSetColumn="tax_item_id" />
              <Mapping SourceColumn="sales_tax_code_id" DataSetColumn="sales_tax_code_id" />
              <Mapping SourceColumn="memo" DataSetColumn="memo" />
              <Mapping SourceColumn="created_by" DataSetColumn="created_by" />
              <Mapping SourceColumn="creation_date" DataSetColumn="creation_date" />
              <Mapping SourceColumn="updated_by" DataSetColumn="updated_by" />
              <Mapping SourceColumn="update_date" DataSetColumn="update_date" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
              <Mapping SourceColumn="account_id" DataSetColumn="account_id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="termsTableAdapter" GeneratorDataComponentClassName="termsTableAdapter" Name="terms" UserDataComponentName="termsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT * FROM `terms`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="inactive" DataSetColumn="inactive" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="employeesTableAdapter" GeneratorDataComponentClassName="employeesTableAdapter" Name="employees" UserDataComponentName="employeesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT * FROM `employees`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="last_name" DataSetColumn="last_name" />
              <Mapping SourceColumn="first_name" DataSetColumn="first_name" />
              <Mapping SourceColumn="middle_name" DataSetColumn="middle_name" />
              <Mapping SourceColumn="street1" DataSetColumn="street1" />
              <Mapping SourceColumn="gender" DataSetColumn="gender" />
              <Mapping SourceColumn="date_of_birth" DataSetColumn="date_of_birth" />
              <Mapping SourceColumn="marital_status" DataSetColumn="marital_status" />
              <Mapping SourceColumn="phone" DataSetColumn="phone" />
              <Mapping SourceColumn="religion" DataSetColumn="religion" />
              <Mapping SourceColumn="zip" DataSetColumn="zip" />
              <Mapping SourceColumn="date_hired" DataSetColumn="date_hired" />
              <Mapping SourceColumn="date_resigned" DataSetColumn="date_resigned" />
              <Mapping SourceColumn="school" DataSetColumn="school" />
              <Mapping SourceColumn="course" DataSetColumn="course" />
              <Mapping SourceColumn="contact" DataSetColumn="contact" />
              <Mapping SourceColumn="branch_id" DataSetColumn="branch_id" />
              <Mapping SourceColumn="department_id" DataSetColumn="department_id" />
              <Mapping SourceColumn="account_no" DataSetColumn="account_no" />
              <Mapping SourceColumn="stat_code" DataSetColumn="stat_code" />
              <Mapping SourceColumn="shift_id" DataSetColumn="shift_id" />
              <Mapping SourceColumn="hdmf" DataSetColumn="hdmf" />
              <Mapping SourceColumn="ss_no" DataSetColumn="ss_no" />
              <Mapping SourceColumn="tin" DataSetColumn="tin" />
              <Mapping SourceColumn="philhealth" DataSetColumn="philhealth" />
              <Mapping SourceColumn="bracket_id" DataSetColumn="bracket_id" />
              <Mapping SourceColumn="ded_hdmf15th" DataSetColumn="ded_hdmf15th" />
              <Mapping SourceColumn="ded_sss15th" DataSetColumn="ded_sss15th" />
              <Mapping SourceColumn="ded_tax15th" DataSetColumn="ded_tax15th" />
              <Mapping SourceColumn="ded_philhealth15th" DataSetColumn="ded_philhealth15th" />
              <Mapping SourceColumn="ded_hdmf30th" DataSetColumn="ded_hdmf30th" />
              <Mapping SourceColumn="ded_sss30th" DataSetColumn="ded_sss30th" />
              <Mapping SourceColumn="ded_tax30th" DataSetColumn="ded_tax30th" />
              <Mapping SourceColumn="ded_philhealth30th" DataSetColumn="ded_philhealth30th" />
              <Mapping SourceColumn="atm" DataSetColumn="atm" />
              <Mapping SourceColumn="seniority_pay" DataSetColumn="seniority_pay" />
              <Mapping SourceColumn="pay_rate" DataSetColumn="pay_rate" />
              <Mapping SourceColumn="vl_allow" DataSetColumn="vl_allow" />
              <Mapping SourceColumn="sl_allow" DataSetColumn="sl_allow" />
              <Mapping SourceColumn="image" DataSetColumn="image" />
              <Mapping SourceColumn="inactive" DataSetColumn="inactive" />
              <Mapping SourceColumn="fingerprint_sig" DataSetColumn="fingerprint_sig" />
              <Mapping SourceColumn="log_exemption" DataSetColumn="log_exemption" />
              <Mapping SourceColumn="salary" DataSetColumn="salary" />
              <Mapping SourceColumn="monthly_rate" DataSetColumn="monthly_rate" />
              <Mapping SourceColumn="daily_rate" DataSetColumn="daily_rate" />
              <Mapping SourceColumn="hourly_rate" DataSetColumn="hourly_rate" />
              <Mapping SourceColumn="position_id" DataSetColumn="position_id" />
              <Mapping SourceColumn="emp_id" DataSetColumn="emp_id" />
              <Mapping SourceColumn="title" DataSetColumn="title" />
              <Mapping SourceColumn="print_on_check_as" DataSetColumn="print_on_check_as" />
              <Mapping SourceColumn="street2" DataSetColumn="street2" />
              <Mapping SourceColumn="city" DataSetColumn="city" />
              <Mapping SourceColumn="state_id" DataSetColumn="state_id" />
              <Mapping SourceColumn="cellular" DataSetColumn="cellular" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="purchase_ordersTableAdapter" GeneratorDataComponentClassName="purchase_ordersTableAdapter" Name="purchase_orders" UserDataComponentName="purchase_ordersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT * FROM `purchase_orders`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="date" DataSetColumn="date" />
              <Mapping SourceColumn="vendor_id" DataSetColumn="vendor_id" />
              <Mapping SourceColumn="prepared_by" DataSetColumn="prepared_by" />
              <Mapping SourceColumn="approved_by" DataSetColumn="approved_by" />
              <Mapping SourceColumn="reference_no" DataSetColumn="reference_no" />
              <Mapping SourceColumn="created_by" DataSetColumn="created_by" />
              <Mapping SourceColumn="creation_date" DataSetColumn="creation_date" />
              <Mapping SourceColumn="updated_by" DataSetColumn="updated_by" />
              <Mapping SourceColumn="update_date" DataSetColumn="update_date" />
              <Mapping SourceColumn="po_no" DataSetColumn="po_no" />
              <Mapping SourceColumn="ship_to_address" DataSetColumn="ship_to_address" />
              <Mapping SourceColumn="vendor_address" DataSetColumn="vendor_address" />
              <Mapping SourceColumn="vendor_message" DataSetColumn="vendor_message" />
              <Mapping SourceColumn="memo" DataSetColumn="memo" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="other_namesTableAdapter" GeneratorDataComponentClassName="other_namesTableAdapter" Name="other_names" UserDataComponentName="other_namesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT * FROM `other_names`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="company_name" DataSetColumn="company_name" />
              <Mapping SourceColumn="title" DataSetColumn="title" />
              <Mapping SourceColumn="first_name" DataSetColumn="first_name" />
              <Mapping SourceColumn="middle_name" DataSetColumn="middle_name" />
              <Mapping SourceColumn="last_name" DataSetColumn="last_name" />
              <Mapping SourceColumn="address" DataSetColumn="address" />
              <Mapping SourceColumn="contact" DataSetColumn="contact" />
              <Mapping SourceColumn="phone" DataSetColumn="phone" />
              <Mapping SourceColumn="fax" DataSetColumn="fax" />
              <Mapping SourceColumn="alt_phone" DataSetColumn="alt_phone" />
              <Mapping SourceColumn="alt_contact" DataSetColumn="alt_contact" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
              <Mapping SourceColumn="account_no" DataSetColumn="account_no" />
              <Mapping SourceColumn="inactive" DataSetColumn="inactive" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="payroll_itemsTableAdapter" GeneratorDataComponentClassName="payroll_itemsTableAdapter" Name="payroll_items" UserDataComponentName="payroll_itemsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT * FROM `payroll_items`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="inactive" DataSetColumn="inactive" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DataSet" msprop:Generator_DataSetName="DataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="customers" msprop:Generator_UserTableName="customers" msprop:Generator_RowDeletedName="customersRowDeleted" msprop:Generator_RowChangedName="customersRowChanged" msprop:Generator_RowClassName="customersRow" msprop:Generator_RowChangingName="customersRowChanging" msprop:Generator_RowEvArgName="customersRowChangeEvent" msprop:Generator_RowEvHandlerName="customersRowChangeEventHandler" msprop:Generator_TableClassName="customersDataTable" msprop:Generator_TableVarName="tablecustomers" msprop:Generator_RowDeletingName="customersRowDeleting" msprop:Generator_TablePropName="customers">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="address" msprop:Generator_UserColumnName="address" msprop:Generator_ColumnPropNameInRow="address" msprop:Generator_ColumnVarNameInTable="columnaddress" msprop:Generator_ColumnPropNameInTable="addressColumn" type="xs:string" minOccurs="0" />
              <xs:element name="phone" msprop:Generator_UserColumnName="phone" msprop:Generator_ColumnPropNameInRow="phone" msprop:Generator_ColumnVarNameInTable="columnphone" msprop:Generator_ColumnPropNameInTable="phoneColumn" type="xs:string" minOccurs="0" />
              <xs:element name="trade_assistance" msprop:Generator_UserColumnName="trade_assistance" msprop:Generator_ColumnPropNameInRow="trade_assistance" msprop:Generator_ColumnVarNameInTable="columntrade_assistance" msprop:Generator_ColumnPropNameInTable="trade_assistanceColumn" type="xs:string" minOccurs="0" />
              <xs:element name="classification" msprop:Generator_UserColumnName="classification" msprop:Generator_ColumnPropNameInRow="classification" msprop:Generator_ColumnVarNameInTable="columnclassification" msprop:Generator_ColumnPropNameInTable="classificationColumn" type="xs:string" minOccurs="0" />
              <xs:element name="type_of_deal" msprop:Generator_UserColumnName="type_of_deal" msprop:Generator_ColumnPropNameInRow="type_of_deal" msprop:Generator_ColumnVarNameInTable="columntype_of_deal" msprop:Generator_ColumnPropNameInTable="type_of_dealColumn" type="xs:string" minOccurs="0" />
              <xs:element name="balance" msprop:Generator_UserColumnName="balance" msprop:Generator_ColumnPropNameInRow="balance" msprop:Generator_ColumnVarNameInTable="columnbalance" msprop:Generator_ColumnPropNameInTable="balanceColumn" type="xs:double" minOccurs="0" />
              <xs:element name="inactive" msprop:Generator_UserColumnName="inactive" msprop:Generator_ColumnPropNameInRow="inactive" msprop:Generator_ColumnVarNameInTable="columninactive" msprop:Generator_ColumnPropNameInTable="inactiveColumn" type="xs:short" minOccurs="0" />
              <xs:element name="company_name" msprop:Generator_UserColumnName="company_name" msprop:Generator_ColumnPropNameInRow="company_name" msprop:Generator_ColumnVarNameInTable="columncompany_name" msprop:Generator_ColumnPropNameInTable="company_nameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="balance_as_of" msprop:Generator_UserColumnName="balance_as_of" msprop:Generator_ColumnPropNameInRow="balance_as_of" msprop:Generator_ColumnVarNameInTable="columnbalance_as_of" msprop:Generator_ColumnPropNameInTable="balance_as_ofColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="title" msprop:Generator_UserColumnName="title" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_ColumnVarNameInTable="columntitle" msprop:Generator_ColumnPropNameInTable="titleColumn" type="xs:string" minOccurs="0" />
              <xs:element name="first_name" msprop:Generator_UserColumnName="first_name" msprop:Generator_ColumnPropNameInRow="first_name" msprop:Generator_ColumnVarNameInTable="columnfirst_name" msprop:Generator_ColumnPropNameInTable="first_nameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="last_name" msprop:Generator_UserColumnName="last_name" msprop:Generator_ColumnPropNameInRow="last_name" msprop:Generator_ColumnVarNameInTable="columnlast_name" msprop:Generator_ColumnPropNameInTable="last_nameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="middle_name" msprop:Generator_UserColumnName="middle_name" msprop:Generator_ColumnPropNameInRow="middle_name" msprop:Generator_ColumnVarNameInTable="columnmiddle_name" msprop:Generator_ColumnPropNameInTable="middle_nameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="ship_to_address" msprop:Generator_UserColumnName="ship_to_address" msprop:Generator_ColumnPropNameInRow="ship_to_address" msprop:Generator_ColumnVarNameInTable="columnship_to_address" msprop:Generator_ColumnPropNameInTable="ship_to_addressColumn" type="xs:string" minOccurs="0" />
              <xs:element name="contact" msprop:Generator_UserColumnName="contact" msprop:Generator_ColumnPropNameInRow="contact" msprop:Generator_ColumnVarNameInTable="columncontact" msprop:Generator_ColumnPropNameInTable="contactColumn" type="xs:string" minOccurs="0" />
              <xs:element name="fax" msprop:Generator_UserColumnName="fax" msprop:Generator_ColumnPropNameInRow="fax" msprop:Generator_ColumnVarNameInTable="columnfax" msprop:Generator_ColumnPropNameInTable="faxColumn" type="xs:string" minOccurs="0" />
              <xs:element name="alt_phone" msprop:Generator_UserColumnName="alt_phone" msprop:Generator_ColumnPropNameInRow="alt_phone" msprop:Generator_ColumnVarNameInTable="columnalt_phone" msprop:Generator_ColumnPropNameInTable="alt_phoneColumn" type="xs:string" minOccurs="0" />
              <xs:element name="alt_contact" msprop:Generator_UserColumnName="alt_contact" msprop:Generator_ColumnPropNameInRow="alt_contact" msprop:Generator_ColumnVarNameInTable="columnalt_contact" msprop:Generator_ColumnPropNameInTable="alt_contactColumn" type="xs:string" minOccurs="0" />
              <xs:element name="email" msprop:Generator_UserColumnName="email" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInTable="emailColumn" type="xs:string" minOccurs="0" />
              <xs:element name="cc" msprop:Generator_UserColumnName="cc" msprop:Generator_ColumnPropNameInRow="cc" msprop:Generator_ColumnVarNameInTable="columncc" msprop:Generator_ColumnPropNameInTable="ccColumn" type="xs:string" minOccurs="0" />
              <xs:element name="customer_type_id" msprop:Generator_UserColumnName="customer_type_id" msprop:Generator_ColumnPropNameInRow="customer_type_id" msprop:Generator_ColumnVarNameInTable="columncustomer_type_id" msprop:Generator_ColumnPropNameInTable="customer_type_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="terms_id" msprop:Generator_UserColumnName="terms_id" msprop:Generator_ColumnPropNameInRow="terms_id" msprop:Generator_ColumnVarNameInTable="columnterms_id" msprop:Generator_ColumnPropNameInTable="terms_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="sales_rep_id" msprop:Generator_UserColumnName="sales_rep_id" msprop:Generator_ColumnPropNameInRow="sales_rep_id" msprop:Generator_ColumnVarNameInTable="columnsales_rep_id" msprop:Generator_ColumnPropNameInTable="sales_rep_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="send_method" msprop:Generator_UserColumnName="send_method" msprop:Generator_ColumnPropNameInRow="send_method" msprop:Generator_ColumnVarNameInTable="columnsend_method" msprop:Generator_ColumnPropNameInTable="send_methodColumn" type="xs:short" minOccurs="0" />
              <xs:element name="sales_tax_code_id" msprop:Generator_UserColumnName="sales_tax_code_id" msprop:Generator_ColumnPropNameInRow="sales_tax_code_id" msprop:Generator_ColumnVarNameInTable="columnsales_tax_code_id" msprop:Generator_ColumnPropNameInTable="sales_tax_code_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="tax_item_id" msprop:Generator_UserColumnName="tax_item_id" msprop:Generator_ColumnPropNameInRow="tax_item_id" msprop:Generator_ColumnVarNameInTable="columntax_item_id" msprop:Generator_ColumnPropNameInTable="tax_item_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="resale_number" msprop:Generator_UserColumnName="resale_number" msprop:Generator_ColumnPropNameInRow="resale_number" msprop:Generator_ColumnVarNameInTable="columnresale_number" msprop:Generator_ColumnPropNameInTable="resale_numberColumn" type="xs:string" minOccurs="0" />
              <xs:element name="price_level_id" msprop:Generator_UserColumnName="price_level_id" msprop:Generator_ColumnPropNameInRow="price_level_id" msprop:Generator_ColumnVarNameInTable="columnprice_level_id" msprop:Generator_ColumnPropNameInTable="price_level_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="account_no" msprop:Generator_UserColumnName="account_no" msprop:Generator_ColumnPropNameInRow="account_no" msprop:Generator_ColumnVarNameInTable="columnaccount_no" msprop:Generator_ColumnPropNameInTable="account_noColumn" type="xs:string" minOccurs="0" />
              <xs:element name="credit_limit" msprop:Generator_UserColumnName="credit_limit" msprop:Generator_ColumnPropNameInRow="credit_limit" msprop:Generator_ColumnVarNameInTable="columncredit_limit" msprop:Generator_ColumnPropNameInTable="credit_limitColumn" type="xs:double" minOccurs="0" />
              <xs:element name="payment_method_id" msprop:Generator_UserColumnName="payment_method_id" msprop:Generator_ColumnPropNameInRow="payment_method_id" msprop:Generator_ColumnVarNameInTable="columnpayment_method_id" msprop:Generator_ColumnPropNameInTable="payment_method_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="credit_card_no" msprop:Generator_UserColumnName="credit_card_no" msprop:Generator_ColumnPropNameInRow="credit_card_no" msprop:Generator_ColumnVarNameInTable="columncredit_card_no" msprop:Generator_ColumnPropNameInTable="credit_card_noColumn" type="xs:string" minOccurs="0" />
              <xs:element name="cc_expiry_month" msprop:Generator_UserColumnName="cc_expiry_month" msprop:Generator_ColumnPropNameInRow="cc_expiry_month" msprop:Generator_ColumnVarNameInTable="columncc_expiry_month" msprop:Generator_ColumnPropNameInTable="cc_expiry_monthColumn" type="xs:string" minOccurs="0" />
              <xs:element name="cc_expiry_year" msprop:Generator_UserColumnName="cc_expiry_year" msprop:Generator_ColumnPropNameInRow="cc_expiry_year" msprop:Generator_ColumnVarNameInTable="columncc_expiry_year" msprop:Generator_ColumnPropNameInTable="cc_expiry_yearColumn" type="xs:string" minOccurs="0" />
              <xs:element name="name_on_card" msprop:Generator_UserColumnName="name_on_card" msprop:Generator_ColumnPropNameInRow="name_on_card" msprop:Generator_ColumnVarNameInTable="columnname_on_card" msprop:Generator_ColumnPropNameInTable="name_on_cardColumn" type="xs:string" minOccurs="0" />
              <xs:element name="cc_address" msprop:Generator_UserColumnName="cc_address" msprop:Generator_ColumnPropNameInRow="cc_address" msprop:Generator_ColumnVarNameInTable="columncc_address" msprop:Generator_ColumnPropNameInTable="cc_addressColumn" type="xs:string" minOccurs="0" />
              <xs:element name="cc_zip_code" msprop:Generator_UserColumnName="cc_zip_code" msprop:Generator_ColumnPropNameInRow="cc_zip_code" msprop:Generator_ColumnVarNameInTable="columncc_zip_code" msprop:Generator_ColumnPropNameInTable="cc_zip_codeColumn" type="xs:string" minOccurs="0" />
              <xs:element name="job_status" msprop:Generator_UserColumnName="job_status" msprop:Generator_ColumnPropNameInRow="job_status" msprop:Generator_ColumnVarNameInTable="columnjob_status" msprop:Generator_ColumnPropNameInTable="job_statusColumn" type="xs:short" minOccurs="0" />
              <xs:element name="start_date" msprop:Generator_UserColumnName="start_date" msprop:Generator_ColumnPropNameInRow="start_date" msprop:Generator_ColumnVarNameInTable="columnstart_date" msprop:Generator_ColumnPropNameInTable="start_dateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="projected_end" msprop:Generator_UserColumnName="projected_end" msprop:Generator_ColumnPropNameInRow="projected_end" msprop:Generator_ColumnVarNameInTable="columnprojected_end" msprop:Generator_ColumnPropNameInTable="projected_endColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="end_date" msprop:Generator_UserColumnName="end_date" msprop:Generator_ColumnPropNameInRow="end_date" msprop:Generator_ColumnVarNameInTable="columnend_date" msprop:Generator_ColumnPropNameInTable="end_dateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="job_description" msprop:Generator_UserColumnName="job_description" msprop:Generator_ColumnPropNameInRow="job_description" msprop:Generator_ColumnVarNameInTable="columnjob_description" msprop:Generator_ColumnPropNameInTable="job_descriptionColumn" type="xs:string" minOccurs="0" />
              <xs:element name="job_type_id" msprop:Generator_UserColumnName="job_type_id" msprop:Generator_ColumnPropNameInRow="job_type_id" msprop:Generator_ColumnVarNameInTable="columnjob_type_id" msprop:Generator_ColumnPropNameInTable="job_type_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="notes" msprop:Generator_UserColumnName="notes" msprop:Generator_ColumnPropNameInRow="notes" msprop:Generator_ColumnVarNameInTable="columnnotes" msprop:Generator_ColumnPropNameInTable="notesColumn" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="vendors" msprop:Generator_UserTableName="vendors" msprop:Generator_RowDeletedName="vendorsRowDeleted" msprop:Generator_RowChangedName="vendorsRowChanged" msprop:Generator_RowClassName="vendorsRow" msprop:Generator_RowChangingName="vendorsRowChanging" msprop:Generator_RowEvArgName="vendorsRowChangeEvent" msprop:Generator_RowEvHandlerName="vendorsRowChangeEventHandler" msprop:Generator_TableClassName="vendorsDataTable" msprop:Generator_TableVarName="tablevendors" msprop:Generator_RowDeletingName="vendorsRowDeleting" msprop:Generator_TablePropName="vendors">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="address" msprop:Generator_UserColumnName="address" msprop:Generator_ColumnPropNameInRow="address" msprop:Generator_ColumnVarNameInTable="columnaddress" msprop:Generator_ColumnPropNameInTable="addressColumn" type="xs:string" minOccurs="0" />
              <xs:element name="phone" msprop:Generator_UserColumnName="phone" msprop:Generator_ColumnPropNameInRow="phone" msprop:Generator_ColumnVarNameInTable="columnphone" msprop:Generator_ColumnPropNameInTable="phoneColumn" type="xs:string" minOccurs="0" />
              <xs:element name="inactive" msprop:Generator_UserColumnName="inactive" msprop:Generator_ColumnPropNameInRow="inactive" msprop:Generator_ColumnVarNameInTable="columninactive" msprop:Generator_ColumnPropNameInTable="inactiveColumn" type="xs:short" minOccurs="0" />
              <xs:element name="balance" msprop:Generator_UserColumnName="balance" msprop:Generator_ColumnPropNameInRow="balance" msprop:Generator_ColumnVarNameInTable="columnbalance" msprop:Generator_ColumnPropNameInTable="balanceColumn" type="xs:double" minOccurs="0" />
              <xs:element name="contact" msprop:Generator_UserColumnName="contact" msprop:Generator_ColumnPropNameInRow="contact" msprop:Generator_ColumnVarNameInTable="columncontact" msprop:Generator_ColumnPropNameInTable="contactColumn" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="company" msprop:Generator_UserTableName="company" msprop:Generator_RowDeletedName="companyRowDeleted" msprop:Generator_RowChangedName="companyRowChanged" msprop:Generator_RowClassName="companyRow" msprop:Generator_RowChangingName="companyRowChanging" msprop:Generator_RowEvArgName="companyRowChangeEvent" msprop:Generator_RowEvHandlerName="companyRowChangeEventHandler" msprop:Generator_TableClassName="companyDataTable" msprop:Generator_TableVarName="tablecompany" msprop:Generator_RowDeletingName="companyRowDeleting" msprop:Generator_TablePropName="company">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="ship_to_name" msprop:Generator_UserColumnName="ship_to_name" msprop:Generator_ColumnPropNameInRow="ship_to_name" msprop:Generator_ColumnVarNameInTable="columnship_to_name" msprop:Generator_ColumnPropNameInTable="ship_to_nameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="ship_to_address" msprop:Generator_UserColumnName="ship_to_address" msprop:Generator_ColumnPropNameInRow="ship_to_address" msprop:Generator_ColumnVarNameInTable="columnship_to_address" msprop:Generator_ColumnPropNameInTable="ship_to_addressColumn" type="xs:string" minOccurs="0" />
              <xs:element name="address" msprop:Generator_UserColumnName="address" msprop:Generator_ColumnPropNameInRow="address" msprop:Generator_ColumnVarNameInTable="columnaddress" msprop:Generator_ColumnPropNameInTable="addressColumn" type="xs:string" minOccurs="0" />
              <xs:element name="phone" msprop:Generator_UserColumnName="phone" msprop:Generator_ColumnPropNameInRow="phone" msprop:Generator_ColumnVarNameInTable="columnphone" msprop:Generator_ColumnPropNameInTable="phoneColumn" type="xs:string" minOccurs="0" />
              <xs:element name="fax" msprop:Generator_UserColumnName="fax" msprop:Generator_ColumnPropNameInRow="fax" msprop:Generator_ColumnVarNameInTable="columnfax" msprop:Generator_ColumnPropNameInTable="faxColumn" type="xs:string" minOccurs="0" />
              <xs:element name="email" msprop:Generator_UserColumnName="email" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInTable="emailColumn" type="xs:string" minOccurs="0" />
              <xs:element name="website" msprop:Generator_UserColumnName="website" msprop:Generator_ColumnPropNameInRow="website" msprop:Generator_ColumnVarNameInTable="columnwebsite" msprop:Generator_ColumnPropNameInTable="websiteColumn" type="xs:string" minOccurs="0" />
              <xs:element name="legal_name" msprop:Generator_UserColumnName="legal_name" msprop:Generator_ColumnPropNameInRow="legal_name" msprop:Generator_ColumnVarNameInTable="columnlegal_name" msprop:Generator_ColumnPropNameInTable="legal_nameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="legal_address" msprop:Generator_UserColumnName="legal_address" msprop:Generator_ColumnPropNameInRow="legal_address" msprop:Generator_ColumnVarNameInTable="columnlegal_address" msprop:Generator_ColumnPropNameInTable="legal_addressColumn" type="xs:string" minOccurs="0" />
              <xs:element name="legal_address1" msprop:Generator_UserColumnName="legal_address1" msprop:Generator_ColumnPropNameInRow="legal_address1" msprop:Generator_ColumnVarNameInTable="columnlegal_address1" msprop:Generator_ColumnPropNameInTable="legal_address1Column" type="xs:string" minOccurs="0" />
              <xs:element name="city" msprop:Generator_UserColumnName="city" msprop:Generator_ColumnPropNameInRow="city" msprop:Generator_ColumnVarNameInTable="columncity" msprop:Generator_ColumnPropNameInTable="cityColumn" type="xs:string" minOccurs="0" />
              <xs:element name="state_id" msprop:Generator_UserColumnName="state_id" msprop:Generator_ColumnPropNameInRow="state_id" msprop:Generator_ColumnVarNameInTable="columnstate_id" msprop:Generator_ColumnPropNameInTable="state_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="zip" msprop:Generator_UserColumnName="zip" msprop:Generator_ColumnPropNameInRow="zip" msprop:Generator_ColumnVarNameInTable="columnzip" msprop:Generator_ColumnPropNameInTable="zipColumn" type="xs:string" minOccurs="0" />
              <xs:element name="legal_country_id" msprop:Generator_UserColumnName="legal_country_id" msprop:Generator_ColumnPropNameInRow="legal_country_id" msprop:Generator_ColumnVarNameInTable="columnlegal_country_id" msprop:Generator_ColumnPropNameInTable="legal_country_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="country_id" msprop:Generator_UserColumnName="country_id" msprop:Generator_ColumnPropNameInRow="country_id" msprop:Generator_ColumnVarNameInTable="columncountry_id" msprop:Generator_ColumnPropNameInTable="country_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="fiscal_year" msprop:Generator_UserColumnName="fiscal_year" msprop:Generator_ColumnPropNameInRow="fiscal_year" msprop:Generator_ColumnVarNameInTable="columnfiscal_year" msprop:Generator_ColumnPropNameInTable="fiscal_yearColumn" type="xs:short" minOccurs="0" />
              <xs:element name="tax_year" msprop:Generator_UserColumnName="tax_year" msprop:Generator_ColumnPropNameInRow="tax_year" msprop:Generator_ColumnVarNameInTable="columntax_year" msprop:Generator_ColumnPropNameInTable="tax_yearColumn" type="xs:short" minOccurs="0" />
              <xs:element name="income_tax_form" msprop:Generator_UserColumnName="income_tax_form" msprop:Generator_ColumnPropNameInRow="income_tax_form" msprop:Generator_ColumnVarNameInTable="columnincome_tax_form" msprop:Generator_ColumnPropNameInTable="income_tax_formColumn" type="xs:short" minOccurs="0" />
              <xs:element name="ein" msprop:Generator_UserColumnName="ein" msprop:Generator_ColumnPropNameInRow="ein" msprop:Generator_ColumnVarNameInTable="columnein" msprop:Generator_ColumnPropNameInTable="einColumn" type="xs:string" minOccurs="0" />
              <xs:element name="ssn" msprop:Generator_UserColumnName="ssn" msprop:Generator_ColumnPropNameInRow="ssn" msprop:Generator_ColumnVarNameInTable="columnssn" msprop:Generator_ColumnPropNameInTable="ssnColumn" type="xs:string" minOccurs="0" />
              <xs:element name="payroll_contact" msprop:Generator_UserColumnName="payroll_contact" msprop:Generator_ColumnPropNameInRow="payroll_contact" msprop:Generator_ColumnVarNameInTable="columnpayroll_contact" msprop:Generator_ColumnPropNameInTable="payroll_contactColumn" type="xs:string" minOccurs="0" />
              <xs:element name="payroll_contact_title" msprop:Generator_UserColumnName="payroll_contact_title" msprop:Generator_ColumnPropNameInRow="payroll_contact_title" msprop:Generator_ColumnVarNameInTable="columnpayroll_contact_title" msprop:Generator_ColumnPropNameInTable="payroll_contact_titleColumn" type="xs:string" minOccurs="0" />
              <xs:element name="payroll_contact_phone" msprop:Generator_UserColumnName="payroll_contact_phone" msprop:Generator_ColumnPropNameInRow="payroll_contact_phone" msprop:Generator_ColumnVarNameInTable="columnpayroll_contact_phone" msprop:Generator_ColumnPropNameInTable="payroll_contact_phoneColumn" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="accounts" msprop:Generator_UserTableName="accounts" msprop:Generator_RowDeletedName="accountsRowDeleted" msprop:Generator_RowChangedName="accountsRowChanged" msprop:Generator_RowClassName="accountsRow" msprop:Generator_RowChangingName="accountsRowChanging" msprop:Generator_RowEvArgName="accountsRowChangeEvent" msprop:Generator_RowEvHandlerName="accountsRowChangeEventHandler" msprop:Generator_TableClassName="accountsDataTable" msprop:Generator_TableVarName="tableaccounts" msprop:Generator_RowDeletingName="accountsRowDeleting" msprop:Generator_TablePropName="accounts">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInTable="descriptionColumn" type="xs:string" minOccurs="0" />
              <xs:element name="note" msprop:Generator_UserColumnName="note" msprop:Generator_ColumnPropNameInRow="note" msprop:Generator_ColumnVarNameInTable="columnnote" msprop:Generator_ColumnPropNameInTable="noteColumn" type="xs:string" minOccurs="0" />
              <xs:element name="balance" msprop:Generator_UserColumnName="balance" msprop:Generator_ColumnPropNameInRow="balance" msprop:Generator_ColumnVarNameInTable="columnbalance" msprop:Generator_ColumnPropNameInTable="balanceColumn" type="xs:double" minOccurs="0" />
              <xs:element name="inactive" msprop:Generator_UserColumnName="inactive" msprop:Generator_ColumnPropNameInRow="inactive" msprop:Generator_ColumnVarNameInTable="columninactive" msprop:Generator_ColumnPropNameInTable="inactiveColumn" type="xs:short" minOccurs="0" />
              <xs:element name="type" msprop:Generator_UserColumnName="type" msprop:Generator_ColumnPropNameInRow="type" msprop:Generator_ColumnVarNameInTable="columntype" msprop:Generator_ColumnPropNameInTable="typeColumn" type="xs:short" minOccurs="0" />
              <xs:element name="tax_line_mapping" msprop:Generator_UserColumnName="tax_line_mapping" msprop:Generator_ColumnPropNameInRow="tax_line_mapping" msprop:Generator_ColumnVarNameInTable="columntax_line_mapping" msprop:Generator_ColumnPropNameInTable="tax_line_mappingColumn" type="xs:short" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="items" msprop:Generator_UserTableName="items" msprop:Generator_RowDeletedName="itemsRowDeleted" msprop:Generator_RowChangedName="itemsRowChanged" msprop:Generator_RowClassName="itemsRow" msprop:Generator_RowChangingName="itemsRowChanging" msprop:Generator_RowEvArgName="itemsRowChangeEvent" msprop:Generator_RowEvHandlerName="itemsRowChangeEventHandler" msprop:Generator_TableClassName="itemsDataTable" msprop:Generator_TableVarName="tableitems" msprop:Generator_RowDeletingName="itemsRowDeleting" msprop:Generator_TablePropName="items">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="sales_description" msprop:Generator_UserColumnName="sales_description" msprop:Generator_ColumnPropNameInRow="sales_description" msprop:Generator_ColumnVarNameInTable="columnsales_description" msprop:Generator_ColumnPropNameInTable="sales_descriptionColumn" type="xs:string" minOccurs="0" />
              <xs:element name="on_hand" msprop:Generator_UserColumnName="on_hand" msprop:Generator_ColumnPropNameInRow="on_hand" msprop:Generator_ColumnVarNameInTable="columnon_hand" msprop:Generator_ColumnPropNameInTable="on_handColumn" type="xs:double" minOccurs="0" />
              <xs:element name="unit_measure" msprop:Generator_UserColumnName="unit_measure" msprop:Generator_ColumnPropNameInRow="unit_measure" msprop:Generator_ColumnVarNameInTable="columnunit_measure" msprop:Generator_ColumnPropNameInTable="unit_measureColumn" type="xs:string" minOccurs="0" />
              <xs:element name="sales_price" msprop:Generator_UserColumnName="sales_price" msprop:Generator_ColumnPropNameInRow="sales_price" msprop:Generator_ColumnVarNameInTable="columnsales_price" msprop:Generator_ColumnPropNameInTable="sales_priceColumn" type="xs:double" minOccurs="0" />
              <xs:element name="reorder_point" msprop:Generator_UserColumnName="reorder_point" msprop:Generator_ColumnPropNameInRow="reorder_point" msprop:Generator_ColumnVarNameInTable="columnreorder_point" msprop:Generator_ColumnPropNameInTable="reorder_pointColumn" type="xs:double" minOccurs="0" />
              <xs:element name="overstock_level" msprop:Generator_UserColumnName="overstock_level" msprop:Generator_ColumnPropNameInRow="overstock_level" msprop:Generator_ColumnVarNameInTable="columnoverstock_level" msprop:Generator_ColumnPropNameInTable="overstock_levelColumn" type="xs:double" minOccurs="0" />
              <xs:element name="part_number" msprop:Generator_UserColumnName="part_number" msprop:Generator_ColumnPropNameInRow="part_number" msprop:Generator_ColumnVarNameInTable="columnpart_number" msprop:Generator_ColumnPropNameInTable="part_numberColumn" type="xs:string" minOccurs="0" />
              <xs:element name="beginning_qty" msprop:Generator_UserColumnName="beginning_qty" msprop:Generator_ColumnPropNameInRow="beginning_qty" msprop:Generator_ColumnVarNameInTable="columnbeginning_qty" msprop:Generator_ColumnPropNameInTable="beginning_qtyColumn" type="xs:double" minOccurs="0" />
              <xs:element name="tolarge_packing" msprop:Generator_UserColumnName="tolarge_packing" msprop:Generator_ColumnPropNameInRow="tolarge_packing" msprop:Generator_ColumnVarNameInTable="columntolarge_packing" msprop:Generator_ColumnPropNameInTable="tolarge_packingColumn" type="xs:double" minOccurs="0" />
              <xs:element name="inactive" msprop:Generator_UserColumnName="inactive" msprop:Generator_ColumnPropNameInRow="inactive" msprop:Generator_ColumnVarNameInTable="columninactive" msprop:Generator_ColumnPropNameInTable="inactiveColumn" type="xs:short" minOccurs="0" />
              <xs:element name="ucs" msprop:Generator_UserColumnName="ucs" msprop:Generator_ColumnPropNameInRow="ucs" msprop:Generator_ColumnVarNameInTable="columnucs" msprop:Generator_ColumnPropNameInTable="ucsColumn" type="xs:double" minOccurs="0" />
              <xs:element name="preferred_vendor_id" msprop:Generator_UserColumnName="preferred_vendor_id" msprop:Generator_ColumnPropNameInRow="preferred_vendor_id" msprop:Generator_ColumnVarNameInTable="columnpreferred_vendor_id" msprop:Generator_ColumnPropNameInTable="preferred_vendor_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="vendor_discount" msprop:Generator_UserColumnName="vendor_discount" msprop:Generator_ColumnPropNameInRow="vendor_discount" msprop:Generator_ColumnVarNameInTable="columnvendor_discount" msprop:Generator_ColumnPropNameInTable="vendor_discountColumn" type="xs:double" minOccurs="0" />
              <xs:element name="purchase_description" msprop:Generator_UserColumnName="purchase_description" msprop:Generator_ColumnPropNameInRow="purchase_description" msprop:Generator_ColumnVarNameInTable="columnpurchase_description" msprop:Generator_ColumnPropNameInTable="purchase_descriptionColumn" type="xs:string" minOccurs="0" />
              <xs:element name="cost" msprop:Generator_UserColumnName="cost" msprop:Generator_ColumnPropNameInRow="cost" msprop:Generator_ColumnVarNameInTable="columncost" msprop:Generator_ColumnPropNameInTable="costColumn" type="xs:double" minOccurs="0" />
              <xs:element name="type" msprop:Generator_UserColumnName="type" msprop:Generator_ColumnPropNameInRow="type" msprop:Generator_ColumnVarNameInTable="columntype" msprop:Generator_ColumnPropNameInTable="typeColumn" type="xs:short" minOccurs="0" />
              <xs:element name="unit_id" msprop:Generator_UserColumnName="unit_id" msprop:Generator_ColumnPropNameInRow="unit_id" msprop:Generator_ColumnVarNameInTable="columnunit_id" msprop:Generator_ColumnPropNameInTable="unit_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="income_account_id" msprop:Generator_UserColumnName="income_account_id" msprop:Generator_ColumnPropNameInRow="income_account_id" msprop:Generator_ColumnVarNameInTable="columnincome_account_id" msprop:Generator_ColumnPropNameInTable="income_account_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="cogs_account_id" msprop:Generator_UserColumnName="cogs_account_id" msprop:Generator_ColumnPropNameInRow="cogs_account_id" msprop:Generator_ColumnVarNameInTable="columncogs_account_id" msprop:Generator_ColumnPropNameInTable="cogs_account_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="sales_tax_code_id" msprop:Generator_UserColumnName="sales_tax_code_id" msprop:Generator_ColumnPropNameInRow="sales_tax_code_id" msprop:Generator_ColumnVarNameInTable="columnsales_tax_code_id" msprop:Generator_ColumnPropNameInTable="sales_tax_code_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="asset_account_id" msprop:Generator_UserColumnName="asset_account_id" msprop:Generator_ColumnPropNameInRow="asset_account_id" msprop:Generator_ColumnVarNameInTable="columnasset_account_id" msprop:Generator_ColumnPropNameInTable="asset_account_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="total_value" msprop:Generator_UserColumnName="total_value" msprop:Generator_ColumnPropNameInRow="total_value" msprop:Generator_ColumnVarNameInTable="columntotal_value" msprop:Generator_ColumnPropNameInTable="total_valueColumn" type="xs:double" minOccurs="0" />
              <xs:element name="value_as_of" msprop:Generator_UserColumnName="value_as_of" msprop:Generator_ColumnPropNameInRow="value_as_of" msprop:Generator_ColumnVarNameInTable="columnvalue_as_of" msprop:Generator_ColumnPropNameInTable="value_as_ofColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="invoices" msprop:Generator_UserTableName="invoices" msprop:Generator_RowDeletedName="invoicesRowDeleted" msprop:Generator_RowChangedName="invoicesRowChanged" msprop:Generator_RowClassName="invoicesRow" msprop:Generator_RowChangingName="invoicesRowChanging" msprop:Generator_RowEvArgName="invoicesRowChangeEvent" msprop:Generator_RowEvHandlerName="invoicesRowChangeEventHandler" msprop:Generator_TableClassName="invoicesDataTable" msprop:Generator_TableVarName="tableinvoices" msprop:Generator_RowDeletingName="invoicesRowDeleting" msprop:Generator_TablePropName="invoices">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="date" msprop:Generator_UserColumnName="date" msprop:Generator_ColumnVarNameInTable="columndate" msprop:Generator_ColumnPropNameInRow="date" msprop:Generator_ColumnPropNameInTable="dateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="customer_id" msprop:Generator_UserColumnName="customer_id" msprop:Generator_ColumnVarNameInTable="columncustomer_id" msprop:Generator_ColumnPropNameInRow="customer_id" msprop:Generator_ColumnPropNameInTable="customer_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ref_no" msprop:Generator_UserColumnName="ref_no" msprop:Generator_ColumnVarNameInTable="columnref_no" msprop:Generator_ColumnPropNameInRow="ref_no" msprop:Generator_ColumnPropNameInTable="ref_noColumn" type="xs:string" minOccurs="0" />
              <xs:element name="bill_to_address" msprop:Generator_UserColumnName="bill_to_address" msprop:Generator_ColumnVarNameInTable="columnbill_to_address" msprop:Generator_ColumnPropNameInRow="bill_to_address" msprop:Generator_ColumnPropNameInTable="bill_to_addressColumn" type="xs:string" minOccurs="0" />
              <xs:element name="ship_to_address" msprop:Generator_UserColumnName="ship_to_address" msprop:Generator_ColumnVarNameInTable="columnship_to_address" msprop:Generator_ColumnPropNameInRow="ship_to_address" msprop:Generator_ColumnPropNameInTable="ship_to_addressColumn" type="xs:string" minOccurs="0" />
              <xs:element name="po_no" msprop:Generator_UserColumnName="po_no" msprop:Generator_ColumnVarNameInTable="columnpo_no" msprop:Generator_ColumnPropNameInRow="po_no" msprop:Generator_ColumnPropNameInTable="po_noColumn" type="xs:string" minOccurs="0" />
              <xs:element name="terms_id" msprop:Generator_UserColumnName="terms_id" msprop:Generator_ColumnVarNameInTable="columnterms_id" msprop:Generator_ColumnPropNameInRow="terms_id" msprop:Generator_ColumnPropNameInTable="terms_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="sales_rep_id" msprop:Generator_UserColumnName="sales_rep_id" msprop:Generator_ColumnVarNameInTable="columnsales_rep_id" msprop:Generator_ColumnPropNameInRow="sales_rep_id" msprop:Generator_ColumnPropNameInTable="sales_rep_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="shipping_date" msprop:Generator_UserColumnName="shipping_date" msprop:Generator_ColumnVarNameInTable="columnshipping_date" msprop:Generator_ColumnPropNameInRow="shipping_date" msprop:Generator_ColumnPropNameInTable="shipping_dateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="shipping_method_id" msprop:Generator_UserColumnName="shipping_method_id" msprop:Generator_ColumnVarNameInTable="columnshipping_method_id" msprop:Generator_ColumnPropNameInRow="shipping_method_id" msprop:Generator_ColumnPropNameInTable="shipping_method_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="fob" msprop:Generator_UserColumnName="fob" msprop:Generator_ColumnVarNameInTable="columnfob" msprop:Generator_ColumnPropNameInRow="fob" msprop:Generator_ColumnPropNameInTable="fobColumn" type="xs:string" minOccurs="0" />
              <xs:element name="customer_message_id" msprop:Generator_UserColumnName="customer_message_id" msprop:Generator_ColumnVarNameInTable="columncustomer_message_id" msprop:Generator_ColumnPropNameInRow="customer_message_id" msprop:Generator_ColumnPropNameInTable="customer_message_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="tax_item_id" msprop:Generator_UserColumnName="tax_item_id" msprop:Generator_ColumnVarNameInTable="columntax_item_id" msprop:Generator_ColumnPropNameInRow="tax_item_id" msprop:Generator_ColumnPropNameInTable="tax_item_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="sales_tax_code_id" msprop:Generator_UserColumnName="sales_tax_code_id" msprop:Generator_ColumnVarNameInTable="columnsales_tax_code_id" msprop:Generator_ColumnPropNameInRow="sales_tax_code_id" msprop:Generator_ColumnPropNameInTable="sales_tax_code_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="memo" msprop:Generator_UserColumnName="memo" msprop:Generator_ColumnVarNameInTable="columnmemo" msprop:Generator_ColumnPropNameInRow="memo" msprop:Generator_ColumnPropNameInTable="memoColumn" type="xs:string" minOccurs="0" />
              <xs:element name="created_by" msprop:Generator_UserColumnName="created_by" msprop:Generator_ColumnVarNameInTable="columncreated_by" msprop:Generator_ColumnPropNameInRow="created_by" msprop:Generator_ColumnPropNameInTable="created_byColumn" type="xs:int" minOccurs="0" />
              <xs:element name="creation_date" msprop:Generator_UserColumnName="creation_date" msprop:Generator_ColumnVarNameInTable="columncreation_date" msprop:Generator_ColumnPropNameInRow="creation_date" msprop:Generator_ColumnPropNameInTable="creation_dateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="updated_by" msprop:Generator_UserColumnName="updated_by" msprop:Generator_ColumnVarNameInTable="columnupdated_by" msprop:Generator_ColumnPropNameInRow="updated_by" msprop:Generator_ColumnPropNameInTable="updated_byColumn" type="xs:int" minOccurs="0" />
              <xs:element name="update_date" msprop:Generator_UserColumnName="update_date" msprop:Generator_ColumnVarNameInTable="columnupdate_date" msprop:Generator_ColumnPropNameInRow="update_date" msprop:Generator_ColumnPropNameInTable="update_dateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="status" msprop:Generator_UserColumnName="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnPropNameInTable="statusColumn" type="xs:short" minOccurs="0" />
              <xs:element name="account_id" msprop:Generator_UserColumnName="account_id" msprop:Generator_ColumnVarNameInTable="columnaccount_id" msprop:Generator_ColumnPropNameInRow="account_id" msprop:Generator_ColumnPropNameInTable="account_idColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="terms" msprop:Generator_UserTableName="terms" msprop:Generator_RowDeletedName="termsRowDeleted" msprop:Generator_RowChangedName="termsRowChanged" msprop:Generator_RowClassName="termsRow" msprop:Generator_RowChangingName="termsRowChanging" msprop:Generator_RowEvArgName="termsRowChangeEvent" msprop:Generator_RowEvHandlerName="termsRowChangeEventHandler" msprop:Generator_TableClassName="termsDataTable" msprop:Generator_TableVarName="tableterms" msprop:Generator_RowDeletingName="termsRowDeleting" msprop:Generator_TablePropName="terms">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="inactive" msprop:Generator_UserColumnName="inactive" msprop:Generator_ColumnVarNameInTable="columninactive" msprop:Generator_ColumnPropNameInRow="inactive" msprop:Generator_ColumnPropNameInTable="inactiveColumn" type="xs:short" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="employees" msprop:Generator_UserTableName="employees" msprop:Generator_RowDeletedName="employeesRowDeleted" msprop:Generator_RowChangedName="employeesRowChanged" msprop:Generator_RowClassName="employeesRow" msprop:Generator_RowChangingName="employeesRowChanging" msprop:Generator_RowEvArgName="employeesRowChangeEvent" msprop:Generator_RowEvHandlerName="employeesRowChangeEventHandler" msprop:Generator_TableClassName="employeesDataTable" msprop:Generator_TableVarName="tableemployees" msprop:Generator_RowDeletingName="employeesRowDeleting" msprop:Generator_TablePropName="employees">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="last_name" msprop:Generator_UserColumnName="last_name" msprop:Generator_ColumnPropNameInRow="last_name" msprop:Generator_ColumnVarNameInTable="columnlast_name" msprop:Generator_ColumnPropNameInTable="last_nameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="first_name" msprop:Generator_UserColumnName="first_name" msprop:Generator_ColumnPropNameInRow="first_name" msprop:Generator_ColumnVarNameInTable="columnfirst_name" msprop:Generator_ColumnPropNameInTable="first_nameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="middle_name" msprop:Generator_UserColumnName="middle_name" msprop:Generator_ColumnPropNameInRow="middle_name" msprop:Generator_ColumnVarNameInTable="columnmiddle_name" msprop:Generator_ColumnPropNameInTable="middle_nameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="street1" msprop:Generator_UserColumnName="street1" msprop:Generator_ColumnPropNameInRow="street1" msprop:Generator_ColumnVarNameInTable="columnstreet1" msprop:Generator_ColumnPropNameInTable="street1Column" type="xs:string" minOccurs="0" />
              <xs:element name="gender" msprop:Generator_UserColumnName="gender" msprop:Generator_ColumnPropNameInRow="gender" msprop:Generator_ColumnVarNameInTable="columngender" msprop:Generator_ColumnPropNameInTable="genderColumn" type="xs:short" minOccurs="0" />
              <xs:element name="date_of_birth" msprop:Generator_UserColumnName="date_of_birth" msprop:Generator_ColumnPropNameInRow="date_of_birth" msprop:Generator_ColumnVarNameInTable="columndate_of_birth" msprop:Generator_ColumnPropNameInTable="date_of_birthColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="marital_status" msprop:Generator_UserColumnName="marital_status" msprop:Generator_ColumnPropNameInRow="marital_status" msprop:Generator_ColumnVarNameInTable="columnmarital_status" msprop:Generator_ColumnPropNameInTable="marital_statusColumn" type="xs:short" minOccurs="0" />
              <xs:element name="phone" msprop:Generator_UserColumnName="phone" msprop:Generator_ColumnPropNameInRow="phone" msprop:Generator_ColumnVarNameInTable="columnphone" msprop:Generator_ColumnPropNameInTable="phoneColumn" type="xs:string" minOccurs="0" />
              <xs:element name="religion" msprop:Generator_UserColumnName="religion" msprop:Generator_ColumnPropNameInRow="religion" msprop:Generator_ColumnVarNameInTable="columnreligion" msprop:Generator_ColumnPropNameInTable="religionColumn" type="xs:string" minOccurs="0" />
              <xs:element name="zip" msprop:Generator_UserColumnName="zip" msprop:Generator_ColumnPropNameInRow="zip" msprop:Generator_ColumnVarNameInTable="columnzip" msprop:Generator_ColumnPropNameInTable="zipColumn" type="xs:string" minOccurs="0" />
              <xs:element name="date_hired" msprop:Generator_UserColumnName="date_hired" msprop:Generator_ColumnPropNameInRow="date_hired" msprop:Generator_ColumnVarNameInTable="columndate_hired" msprop:Generator_ColumnPropNameInTable="date_hiredColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="date_resigned" msprop:Generator_UserColumnName="date_resigned" msprop:Generator_ColumnPropNameInRow="date_resigned" msprop:Generator_ColumnVarNameInTable="columndate_resigned" msprop:Generator_ColumnPropNameInTable="date_resignedColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="school" msprop:Generator_UserColumnName="school" msprop:Generator_ColumnPropNameInRow="school" msprop:Generator_ColumnVarNameInTable="columnschool" msprop:Generator_ColumnPropNameInTable="schoolColumn" type="xs:string" minOccurs="0" />
              <xs:element name="course" msprop:Generator_UserColumnName="course" msprop:Generator_ColumnPropNameInRow="course" msprop:Generator_ColumnVarNameInTable="columncourse" msprop:Generator_ColumnPropNameInTable="courseColumn" type="xs:string" minOccurs="0" />
              <xs:element name="contact" msprop:Generator_UserColumnName="contact" msprop:Generator_ColumnPropNameInRow="contact" msprop:Generator_ColumnVarNameInTable="columncontact" msprop:Generator_ColumnPropNameInTable="contactColumn" type="xs:string" minOccurs="0" />
              <xs:element name="branch_id" msprop:Generator_UserColumnName="branch_id" msprop:Generator_ColumnPropNameInRow="branch_id" msprop:Generator_ColumnVarNameInTable="columnbranch_id" msprop:Generator_ColumnPropNameInTable="branch_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="department_id" msprop:Generator_UserColumnName="department_id" msprop:Generator_ColumnPropNameInRow="department_id" msprop:Generator_ColumnVarNameInTable="columndepartment_id" msprop:Generator_ColumnPropNameInTable="department_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="account_no" msprop:Generator_UserColumnName="account_no" msprop:Generator_ColumnPropNameInRow="account_no" msprop:Generator_ColumnVarNameInTable="columnaccount_no" msprop:Generator_ColumnPropNameInTable="account_noColumn" type="xs:string" minOccurs="0" />
              <xs:element name="stat_code" msprop:Generator_UserColumnName="stat_code" msprop:Generator_ColumnPropNameInRow="stat_code" msprop:Generator_ColumnVarNameInTable="columnstat_code" msprop:Generator_ColumnPropNameInTable="stat_codeColumn" type="xs:string" minOccurs="0" />
              <xs:element name="shift_id" msprop:Generator_UserColumnName="shift_id" msprop:Generator_ColumnPropNameInRow="shift_id" msprop:Generator_ColumnVarNameInTable="columnshift_id" msprop:Generator_ColumnPropNameInTable="shift_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="hdmf" msprop:Generator_UserColumnName="hdmf" msprop:Generator_ColumnPropNameInRow="hdmf" msprop:Generator_ColumnVarNameInTable="columnhdmf" msprop:Generator_ColumnPropNameInTable="hdmfColumn" type="xs:string" minOccurs="0" />
              <xs:element name="ss_no" msprop:Generator_UserColumnName="ss_no" msprop:Generator_ColumnPropNameInRow="ss_no" msprop:Generator_ColumnVarNameInTable="columnss_no" msprop:Generator_ColumnPropNameInTable="ss_noColumn" type="xs:string" minOccurs="0" />
              <xs:element name="tin" msprop:Generator_UserColumnName="tin" msprop:Generator_ColumnPropNameInRow="tin" msprop:Generator_ColumnVarNameInTable="columntin" msprop:Generator_ColumnPropNameInTable="tinColumn" type="xs:string" minOccurs="0" />
              <xs:element name="philhealth" msprop:Generator_UserColumnName="philhealth" msprop:Generator_ColumnPropNameInRow="philhealth" msprop:Generator_ColumnVarNameInTable="columnphilhealth" msprop:Generator_ColumnPropNameInTable="philhealthColumn" type="xs:string" minOccurs="0" />
              <xs:element name="bracket_id" msprop:Generator_UserColumnName="bracket_id" msprop:Generator_ColumnPropNameInRow="bracket_id" msprop:Generator_ColumnVarNameInTable="columnbracket_id" msprop:Generator_ColumnPropNameInTable="bracket_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ded_hdmf15th" msprop:Generator_UserColumnName="ded_hdmf15th" msprop:Generator_ColumnPropNameInRow="ded_hdmf15th" msprop:Generator_ColumnVarNameInTable="columnded_hdmf15th" msprop:Generator_ColumnPropNameInTable="ded_hdmf15thColumn" type="xs:short" minOccurs="0" />
              <xs:element name="ded_sss15th" msprop:Generator_UserColumnName="ded_sss15th" msprop:Generator_ColumnPropNameInRow="ded_sss15th" msprop:Generator_ColumnVarNameInTable="columnded_sss15th" msprop:Generator_ColumnPropNameInTable="ded_sss15thColumn" type="xs:short" minOccurs="0" />
              <xs:element name="ded_tax15th" msprop:Generator_UserColumnName="ded_tax15th" msprop:Generator_ColumnPropNameInRow="ded_tax15th" msprop:Generator_ColumnVarNameInTable="columnded_tax15th" msprop:Generator_ColumnPropNameInTable="ded_tax15thColumn" type="xs:short" minOccurs="0" />
              <xs:element name="ded_philhealth15th" msprop:Generator_UserColumnName="ded_philhealth15th" msprop:Generator_ColumnPropNameInRow="ded_philhealth15th" msprop:Generator_ColumnVarNameInTable="columnded_philhealth15th" msprop:Generator_ColumnPropNameInTable="ded_philhealth15thColumn" type="xs:short" minOccurs="0" />
              <xs:element name="ded_hdmf30th" msprop:Generator_UserColumnName="ded_hdmf30th" msprop:Generator_ColumnPropNameInRow="ded_hdmf30th" msprop:Generator_ColumnVarNameInTable="columnded_hdmf30th" msprop:Generator_ColumnPropNameInTable="ded_hdmf30thColumn" type="xs:short" minOccurs="0" />
              <xs:element name="ded_sss30th" msprop:Generator_UserColumnName="ded_sss30th" msprop:Generator_ColumnPropNameInRow="ded_sss30th" msprop:Generator_ColumnVarNameInTable="columnded_sss30th" msprop:Generator_ColumnPropNameInTable="ded_sss30thColumn" type="xs:short" minOccurs="0" />
              <xs:element name="ded_tax30th" msprop:Generator_UserColumnName="ded_tax30th" msprop:Generator_ColumnPropNameInRow="ded_tax30th" msprop:Generator_ColumnVarNameInTable="columnded_tax30th" msprop:Generator_ColumnPropNameInTable="ded_tax30thColumn" type="xs:short" minOccurs="0" />
              <xs:element name="ded_philhealth30th" msprop:Generator_UserColumnName="ded_philhealth30th" msprop:Generator_ColumnPropNameInRow="ded_philhealth30th" msprop:Generator_ColumnVarNameInTable="columnded_philhealth30th" msprop:Generator_ColumnPropNameInTable="ded_philhealth30thColumn" type="xs:short" minOccurs="0" />
              <xs:element name="atm" msprop:Generator_UserColumnName="atm" msprop:Generator_ColumnPropNameInRow="atm" msprop:Generator_ColumnVarNameInTable="columnatm" msprop:Generator_ColumnPropNameInTable="atmColumn" type="xs:string" minOccurs="0" />
              <xs:element name="seniority_pay" msprop:Generator_UserColumnName="seniority_pay" msprop:Generator_ColumnPropNameInRow="seniority_pay" msprop:Generator_ColumnVarNameInTable="columnseniority_pay" msprop:Generator_ColumnPropNameInTable="seniority_payColumn" type="xs:double" minOccurs="0" />
              <xs:element name="pay_rate" msprop:Generator_UserColumnName="pay_rate" msprop:Generator_ColumnPropNameInRow="pay_rate" msprop:Generator_ColumnVarNameInTable="columnpay_rate" msprop:Generator_ColumnPropNameInTable="pay_rateColumn" type="xs:double" minOccurs="0" />
              <xs:element name="vl_allow" msprop:Generator_UserColumnName="vl_allow" msprop:Generator_ColumnPropNameInRow="vl_allow" msprop:Generator_ColumnVarNameInTable="columnvl_allow" msprop:Generator_ColumnPropNameInTable="vl_allowColumn" type="xs:double" minOccurs="0" />
              <xs:element name="sl_allow" msprop:Generator_UserColumnName="sl_allow" msprop:Generator_ColumnPropNameInRow="sl_allow" msprop:Generator_ColumnVarNameInTable="columnsl_allow" msprop:Generator_ColumnPropNameInTable="sl_allowColumn" type="xs:double" minOccurs="0" />
              <xs:element name="image" msprop:Generator_UserColumnName="image" msprop:Generator_ColumnPropNameInRow="image" msprop:Generator_ColumnVarNameInTable="columnimage" msprop:Generator_ColumnPropNameInTable="imageColumn" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="inactive" msprop:Generator_UserColumnName="inactive" msprop:Generator_ColumnPropNameInRow="inactive" msprop:Generator_ColumnVarNameInTable="columninactive" msprop:Generator_ColumnPropNameInTable="inactiveColumn" type="xs:short" minOccurs="0" />
              <xs:element name="fingerprint_sig" msprop:Generator_UserColumnName="fingerprint_sig" msprop:Generator_ColumnPropNameInRow="fingerprint_sig" msprop:Generator_ColumnVarNameInTable="columnfingerprint_sig" msprop:Generator_ColumnPropNameInTable="fingerprint_sigColumn" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="log_exemption" msprop:Generator_UserColumnName="log_exemption" msprop:Generator_ColumnPropNameInRow="log_exemption" msprop:Generator_ColumnVarNameInTable="columnlog_exemption" msprop:Generator_ColumnPropNameInTable="log_exemptionColumn" type="xs:short" minOccurs="0" />
              <xs:element name="salary" msprop:Generator_UserColumnName="salary" msprop:Generator_ColumnPropNameInRow="salary" msprop:Generator_ColumnVarNameInTable="columnsalary" msprop:Generator_ColumnPropNameInTable="salaryColumn" type="xs:double" minOccurs="0" />
              <xs:element name="monthly_rate" msprop:Generator_UserColumnName="monthly_rate" msprop:Generator_ColumnPropNameInRow="monthly_rate" msprop:Generator_ColumnVarNameInTable="columnmonthly_rate" msprop:Generator_ColumnPropNameInTable="monthly_rateColumn" type="xs:double" minOccurs="0" />
              <xs:element name="daily_rate" msprop:Generator_UserColumnName="daily_rate" msprop:Generator_ColumnPropNameInRow="daily_rate" msprop:Generator_ColumnVarNameInTable="columndaily_rate" msprop:Generator_ColumnPropNameInTable="daily_rateColumn" type="xs:double" minOccurs="0" />
              <xs:element name="hourly_rate" msprop:Generator_UserColumnName="hourly_rate" msprop:Generator_ColumnPropNameInRow="hourly_rate" msprop:Generator_ColumnVarNameInTable="columnhourly_rate" msprop:Generator_ColumnPropNameInTable="hourly_rateColumn" type="xs:double" minOccurs="0" />
              <xs:element name="position_id" msprop:Generator_UserColumnName="position_id" msprop:Generator_ColumnPropNameInRow="position_id" msprop:Generator_ColumnVarNameInTable="columnposition_id" msprop:Generator_ColumnPropNameInTable="position_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="emp_id" msprop:Generator_UserColumnName="emp_id" msprop:Generator_ColumnPropNameInRow="emp_id" msprop:Generator_ColumnVarNameInTable="columnemp_id" msprop:Generator_ColumnPropNameInTable="emp_idColumn" type="xs:string" minOccurs="0" />
              <xs:element name="title" msprop:Generator_UserColumnName="title" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_ColumnVarNameInTable="columntitle" msprop:Generator_ColumnPropNameInTable="titleColumn" type="xs:string" minOccurs="0" />
              <xs:element name="print_on_check_as" msprop:Generator_UserColumnName="print_on_check_as" msprop:Generator_ColumnPropNameInRow="print_on_check_as" msprop:Generator_ColumnVarNameInTable="columnprint_on_check_as" msprop:Generator_ColumnPropNameInTable="print_on_check_asColumn" type="xs:string" minOccurs="0" />
              <xs:element name="street2" msprop:Generator_UserColumnName="street2" msprop:Generator_ColumnPropNameInRow="street2" msprop:Generator_ColumnVarNameInTable="columnstreet2" msprop:Generator_ColumnPropNameInTable="street2Column" type="xs:string" minOccurs="0" />
              <xs:element name="city" msprop:Generator_UserColumnName="city" msprop:Generator_ColumnPropNameInRow="city" msprop:Generator_ColumnVarNameInTable="columncity" msprop:Generator_ColumnPropNameInTable="cityColumn" type="xs:string" minOccurs="0" />
              <xs:element name="state_id" msprop:Generator_UserColumnName="state_id" msprop:Generator_ColumnPropNameInRow="state_id" msprop:Generator_ColumnVarNameInTable="columnstate_id" msprop:Generator_ColumnPropNameInTable="state_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="cellular" msprop:Generator_UserColumnName="cellular" msprop:Generator_ColumnPropNameInRow="cellular" msprop:Generator_ColumnVarNameInTable="columncellular" msprop:Generator_ColumnPropNameInTable="cellularColumn" type="xs:string" minOccurs="0" />
              <xs:element name="email" msprop:Generator_UserColumnName="email" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInTable="emailColumn" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="purchase_orders" msprop:Generator_UserTableName="purchase_orders" msprop:Generator_RowDeletedName="purchase_ordersRowDeleted" msprop:Generator_RowChangedName="purchase_ordersRowChanged" msprop:Generator_RowClassName="purchase_ordersRow" msprop:Generator_RowChangingName="purchase_ordersRowChanging" msprop:Generator_RowEvArgName="purchase_ordersRowChangeEvent" msprop:Generator_RowEvHandlerName="purchase_ordersRowChangeEventHandler" msprop:Generator_TableClassName="purchase_ordersDataTable" msprop:Generator_TableVarName="tablepurchase_orders" msprop:Generator_RowDeletingName="purchase_ordersRowDeleting" msprop:Generator_TablePropName="purchase_orders">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="date" msprop:Generator_UserColumnName="date" msprop:Generator_ColumnPropNameInRow="date" msprop:Generator_ColumnVarNameInTable="columndate" msprop:Generator_ColumnPropNameInTable="dateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="vendor_id" msprop:Generator_UserColumnName="vendor_id" msprop:Generator_ColumnPropNameInRow="vendor_id" msprop:Generator_ColumnVarNameInTable="columnvendor_id" msprop:Generator_ColumnPropNameInTable="vendor_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="prepared_by" msprop:Generator_UserColumnName="prepared_by" msprop:Generator_ColumnPropNameInRow="prepared_by" msprop:Generator_ColumnVarNameInTable="columnprepared_by" msprop:Generator_ColumnPropNameInTable="prepared_byColumn" type="xs:string" minOccurs="0" />
              <xs:element name="approved_by" msprop:Generator_UserColumnName="approved_by" msprop:Generator_ColumnPropNameInRow="approved_by" msprop:Generator_ColumnVarNameInTable="columnapproved_by" msprop:Generator_ColumnPropNameInTable="approved_byColumn" type="xs:string" minOccurs="0" />
              <xs:element name="reference_no" msprop:Generator_UserColumnName="reference_no" msprop:Generator_ColumnPropNameInRow="reference_no" msprop:Generator_ColumnVarNameInTable="columnreference_no" msprop:Generator_ColumnPropNameInTable="reference_noColumn" type="xs:string" minOccurs="0" />
              <xs:element name="created_by" msprop:Generator_UserColumnName="created_by" msprop:Generator_ColumnPropNameInRow="created_by" msprop:Generator_ColumnVarNameInTable="columncreated_by" msprop:Generator_ColumnPropNameInTable="created_byColumn" type="xs:int" minOccurs="0" />
              <xs:element name="creation_date" msprop:Generator_UserColumnName="creation_date" msprop:Generator_ColumnPropNameInRow="creation_date" msprop:Generator_ColumnVarNameInTable="columncreation_date" msprop:Generator_ColumnPropNameInTable="creation_dateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="updated_by" msprop:Generator_UserColumnName="updated_by" msprop:Generator_ColumnPropNameInRow="updated_by" msprop:Generator_ColumnVarNameInTable="columnupdated_by" msprop:Generator_ColumnPropNameInTable="updated_byColumn" type="xs:int" minOccurs="0" />
              <xs:element name="update_date" msprop:Generator_UserColumnName="update_date" msprop:Generator_ColumnPropNameInRow="update_date" msprop:Generator_ColumnVarNameInTable="columnupdate_date" msprop:Generator_ColumnPropNameInTable="update_dateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="po_no" msprop:Generator_UserColumnName="po_no" msprop:Generator_ColumnPropNameInRow="po_no" msprop:Generator_ColumnVarNameInTable="columnpo_no" msprop:Generator_ColumnPropNameInTable="po_noColumn" type="xs:string" minOccurs="0" />
              <xs:element name="ship_to_address" msprop:Generator_UserColumnName="ship_to_address" msprop:Generator_ColumnPropNameInRow="ship_to_address" msprop:Generator_ColumnVarNameInTable="columnship_to_address" msprop:Generator_ColumnPropNameInTable="ship_to_addressColumn" type="xs:string" minOccurs="0" />
              <xs:element name="vendor_address" msprop:Generator_UserColumnName="vendor_address" msprop:Generator_ColumnPropNameInRow="vendor_address" msprop:Generator_ColumnVarNameInTable="columnvendor_address" msprop:Generator_ColumnPropNameInTable="vendor_addressColumn" type="xs:string" minOccurs="0" />
              <xs:element name="vendor_message" msprop:Generator_UserColumnName="vendor_message" msprop:Generator_ColumnPropNameInRow="vendor_message" msprop:Generator_ColumnVarNameInTable="columnvendor_message" msprop:Generator_ColumnPropNameInTable="vendor_messageColumn" type="xs:string" minOccurs="0" />
              <xs:element name="memo" msprop:Generator_UserColumnName="memo" msprop:Generator_ColumnPropNameInRow="memo" msprop:Generator_ColumnVarNameInTable="columnmemo" msprop:Generator_ColumnPropNameInTable="memoColumn" type="xs:string" minOccurs="0" />
              <xs:element name="status" msprop:Generator_UserColumnName="status" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInTable="statusColumn" type="xs:short" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="other_names" msprop:Generator_UserTableName="other_names" msprop:Generator_RowDeletedName="other_namesRowDeleted" msprop:Generator_RowChangedName="other_namesRowChanged" msprop:Generator_RowClassName="other_namesRow" msprop:Generator_RowChangingName="other_namesRowChanging" msprop:Generator_RowEvArgName="other_namesRowChangeEvent" msprop:Generator_RowEvHandlerName="other_namesRowChangeEventHandler" msprop:Generator_TableClassName="other_namesDataTable" msprop:Generator_TableVarName="tableother_names" msprop:Generator_RowDeletingName="other_namesRowDeleting" msprop:Generator_TablePropName="other_names">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="company_name" msprop:Generator_UserColumnName="company_name" msprop:Generator_ColumnVarNameInTable="columncompany_name" msprop:Generator_ColumnPropNameInRow="company_name" msprop:Generator_ColumnPropNameInTable="company_nameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="title" msprop:Generator_UserColumnName="title" msprop:Generator_ColumnVarNameInTable="columntitle" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_ColumnPropNameInTable="titleColumn" type="xs:string" minOccurs="0" />
              <xs:element name="first_name" msprop:Generator_UserColumnName="first_name" msprop:Generator_ColumnVarNameInTable="columnfirst_name" msprop:Generator_ColumnPropNameInRow="first_name" msprop:Generator_ColumnPropNameInTable="first_nameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="middle_name" msprop:Generator_UserColumnName="middle_name" msprop:Generator_ColumnVarNameInTable="columnmiddle_name" msprop:Generator_ColumnPropNameInRow="middle_name" msprop:Generator_ColumnPropNameInTable="middle_nameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="last_name" msprop:Generator_UserColumnName="last_name" msprop:Generator_ColumnVarNameInTable="columnlast_name" msprop:Generator_ColumnPropNameInRow="last_name" msprop:Generator_ColumnPropNameInTable="last_nameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="address" msprop:Generator_UserColumnName="address" msprop:Generator_ColumnVarNameInTable="columnaddress" msprop:Generator_ColumnPropNameInRow="address" msprop:Generator_ColumnPropNameInTable="addressColumn" type="xs:string" minOccurs="0" />
              <xs:element name="contact" msprop:Generator_UserColumnName="contact" msprop:Generator_ColumnVarNameInTable="columncontact" msprop:Generator_ColumnPropNameInRow="contact" msprop:Generator_ColumnPropNameInTable="contactColumn" type="xs:string" minOccurs="0" />
              <xs:element name="phone" msprop:Generator_UserColumnName="phone" msprop:Generator_ColumnVarNameInTable="columnphone" msprop:Generator_ColumnPropNameInRow="phone" msprop:Generator_ColumnPropNameInTable="phoneColumn" type="xs:string" minOccurs="0" />
              <xs:element name="fax" msprop:Generator_UserColumnName="fax" msprop:Generator_ColumnVarNameInTable="columnfax" msprop:Generator_ColumnPropNameInRow="fax" msprop:Generator_ColumnPropNameInTable="faxColumn" type="xs:string" minOccurs="0" />
              <xs:element name="alt_phone" msprop:Generator_UserColumnName="alt_phone" msprop:Generator_ColumnVarNameInTable="columnalt_phone" msprop:Generator_ColumnPropNameInRow="alt_phone" msprop:Generator_ColumnPropNameInTable="alt_phoneColumn" type="xs:string" minOccurs="0" />
              <xs:element name="alt_contact" msprop:Generator_UserColumnName="alt_contact" msprop:Generator_ColumnVarNameInTable="columnalt_contact" msprop:Generator_ColumnPropNameInRow="alt_contact" msprop:Generator_ColumnPropNameInTable="alt_contactColumn" type="xs:string" minOccurs="0" />
              <xs:element name="email" msprop:Generator_UserColumnName="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" type="xs:string" minOccurs="0" />
              <xs:element name="account_no" msprop:Generator_UserColumnName="account_no" msprop:Generator_ColumnVarNameInTable="columnaccount_no" msprop:Generator_ColumnPropNameInRow="account_no" msprop:Generator_ColumnPropNameInTable="account_noColumn" type="xs:string" minOccurs="0" />
              <xs:element name="inactive" msprop:Generator_UserColumnName="inactive" msprop:Generator_ColumnVarNameInTable="columninactive" msprop:Generator_ColumnPropNameInRow="inactive" msprop:Generator_ColumnPropNameInTable="inactiveColumn" type="xs:short" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="payroll_items" msprop:Generator_UserTableName="payroll_items" msprop:Generator_RowDeletedName="payroll_itemsRowDeleted" msprop:Generator_TableClassName="payroll_itemsDataTable" msprop:Generator_RowChangedName="payroll_itemsRowChanged" msprop:Generator_RowClassName="payroll_itemsRow" msprop:Generator_RowChangingName="payroll_itemsRowChanging" msprop:Generator_RowEvArgName="payroll_itemsRowChangeEvent" msprop:Generator_RowEvHandlerName="payroll_itemsRowChangeEventHandler" msprop:Generator_TablePropName="payroll_items" msprop:Generator_TableVarName="tablepayroll_items" msprop:Generator_RowDeletingName="payroll_itemsRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="inactive" msprop:Generator_UserColumnName="inactive" msprop:Generator_ColumnPropNameInRow="inactive" msprop:Generator_ColumnVarNameInTable="columninactive" msprop:Generator_ColumnPropNameInTable="inactiveColumn" type="xs:short" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1">
      <xs:selector xpath=".//mstns:customers" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="vendors_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:vendors" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="company_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:company" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="accounts_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:accounts" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="items_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:items" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="invoices_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:invoices" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="terms_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:terms" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="employees_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:employees" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="purchase_orders_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:purchase_orders" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="other_names_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:other_names" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="payroll_items_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:payroll_items" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
  </xs:element>
</xs:schema>